Project Overview
This project explores the optimization of a two-stock portfolio and the construction of the efficient frontier. Using historical return data, we analyze the returns, standard deviations, and correlation of the two stocks. Additionally, the minimum variance portfolio and the impact of incorporating a risk-free rate are evaluated.
Key Outcomes
- Calculated the average returns and standard deviations of Stock 1 and Stock 2.
- Determined the correlation coefficient between the two stocks.
- Identified the weights for the minimum variance portfolio.
- Visualized the efficient frontier, incorporating the risk-free rate.
Tools and Techniques
- Microsoft Excel for calculations and visualizations.
- Portfolio theory concepts including average return, standard deviation, and correlation.
- Efficient frontier and minimum variance portfolio analysis.
Applications
- Investment strategy optimization for risk-averse and risk-seeking investors.
- Understanding trade-offs between risk and return in portfolio management.
- Real-world portfolio design incorporating risk-free assets.